<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="generator" content="ApiGen 2.8.0">
	<meta name="robots" content="noindex">

	<title>File familia.php</title>

	<script type="text/javascript" src="resources/combined.js?3770084987"></script>
	<script type="text/javascript" src="elementlist.js?553530925"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360">

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
		</div>



		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-agente.html">agente</a></li>
				<li><a href="class-albaran_cliente.html">albaran_cliente</a></li>
				<li><a href="class-albaran_proveedor.html">albaran_proveedor</a></li>
				<li><a href="class-almacen.html">almacen</a></li>
				<li><a href="class-articulo.html">articulo</a></li>
				<li><a href="class-asiento.html">asiento</a></li>
				<li><a href="class-asiento_factura.html">asiento_factura</a></li>
				<li><a href="class-balance.html">balance</a></li>
				<li><a href="class-balance_cuenta.html">balance_cuenta</a></li>
				<li><a href="class-balance_cuenta_a.html">balance_cuenta_a</a></li>
				<li><a href="class-banco.html">banco</a></li>
				<li><a href="class-caja.html">caja</a></li>
				<li><a href="class-cliente.html">cliente</a></li>
				<li><a href="class-concepto_partida.html">concepto_partida</a></li>
				<li><a href="class-cuenta.html">cuenta</a></li>
				<li><a href="class-cuenta_banco.html">cuenta_banco</a></li>
				<li><a href="class-cuenta_banco_cliente.html">cuenta_banco_cliente</a></li>
				<li><a href="class-cuenta_banco_proveedor.html">cuenta_banco_proveedor</a></li>
				<li><a href="class-cuenta_especial.html">cuenta_especial</a></li>
				<li><a href="class-direccion_cliente.html">direccion_cliente</a></li>
				<li><a href="class-direccion_proveedor.html">direccion_proveedor</a></li>
				<li><a href="class-divisa.html">divisa</a></li>
				<li><a href="class-ejercicio.html">ejercicio</a></li>
				<li><a href="class-empresa.html">empresa</a></li>
				<li><a href="class-epigrafe.html">epigrafe</a></li>
				<li><a href="class-factura_cliente.html">factura_cliente</a></li>
				<li><a href="class-factura_proveedor.html">factura_proveedor</a></li>
				<li class="active"><a href="class-familia.html">familia</a></li>
				<li><a href="class-forma_pago.html">forma_pago</a></li>
				<li><a href="class-fs_access.html">fs_access</a></li>
				<li><a href="class-fs_button.html">fs_button</a></li>
				<li><a href="class-fs_button_img.html">fs_button_img</a></li>
				<li><a href="class-fs_cache.html">fs_cache</a></li>
				<li><a href="class-fs_controller.html">fs_controller</a></li>
				<li><a href="class-fs_db.html">fs_db</a></li>
				<li><a href="class-fs_default_items.html">fs_default_items</a></li>
				<li><a href="class-fs_extension.html">fs_extension</a></li>
				<li><a href="class-fs_log.html">fs_log</a></li>
				<li><a href="class-fs_model.html">fs_model</a></li>
				<li><a href="class-fs_mysql.html">fs_mysql</a></li>
				<li><a href="class-fs_page.html">fs_page</a></li>
				<li><a href="class-fs_pdf.html">fs_pdf</a></li>
				<li><a href="class-fs_postgresql.html">fs_postgresql</a></li>
				<li><a href="class-fs_printer.html">fs_printer</a></li>
				<li><a href="class-fs_user.html">fs_user</a></li>
				<li><a href="class-fs_var.html">fs_var</a></li>
				<li><a href="class-grupo_clientes.html">grupo_clientes</a></li>
				<li><a href="class-grupo_epigrafes.html">grupo_epigrafes</a></li>
				<li><a href="class-impuesto.html">impuesto</a></li>
				<li><a href="class-linea_albaran_cliente.html">linea_albaran_cliente</a></li>
				<li><a href="class-linea_albaran_proveedor.html">linea_albaran_proveedor</a></li>
				<li><a href="class-linea_factura_cliente.html">linea_factura_cliente</a></li>
				<li><a href="class-linea_factura_proveedor.html">linea_factura_proveedor</a></li>
				<li><a href="class-linea_iva_factura_cliente.html">linea_iva_factura_cliente</a></li>
				<li><a href="class-linea_iva_factura_proveedor.html">linea_iva_factura_proveedor</a></li>
				<li><a href="class-pais.html">pais</a></li>
				<li><a href="class-partida.html">partida</a></li>
				<li><a href="class-proveedor.html">proveedor</a></li>
				<li><a href="class-regularizacion_iva.html">regularizacion_iva</a></li>
				<li><a href="class-secuencia.html">secuencia</a></li>
				<li><a href="class-secuencia_contabilidad.html">secuencia_contabilidad</a></li>
				<li><a href="class-secuencia_ejercicio.html">secuencia_ejercicio</a></li>
				<li><a href="class-serie.html">serie</a></li>
				<li><a href="class-stock.html">stock</a></li>
				<li><a href="class-subcuenta.html">subcuenta</a></li>
				<li><a href="class-subcuenta_cliente.html">subcuenta_cliente</a></li>
				<li><a href="class-subcuenta_proveedor.html">subcuenta_proveedor</a></li>
				<li><a href="class-sucursal.html">sucursal</a></li>
				<li><a href="class-tarifa.html">tarifa</a></li>
				<li><a href="class-tarifa_articulo.html">tarifa_articulo</a></li>
			</ul>





			<h3>Functions</h3>
			<ul>
				<li><a href="function-bround.html">bround</a></li>
				<li><a href="function-require_model.html">require_model</a></li>
			</ul>
		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="">
		<input type="hidden" name="ie" value="UTF-8">
		<input type="text" name="q" class="text">
		<input type="submit" value="Search">
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="class-familia.html" title="Summary of familia"><span>Class</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><span id="1" class="l"><a class="l" href="#1">  1: </a><span class="xlang">&lt;?php</span>
</span><span id="2" class="l"><a class="l" href="#2">  2: </a><span class="php-comment">/*
</span></span><span id="3" class="l"><a class="l" href="#3">  3: </a><span class="php-comment"> * This file is part of FacturaSctipts
</span></span><span id="4" class="l"><a class="l" href="#4">  4: </a><span class="php-comment"> * Copyright (C) 2014  Carlos Garcia Gomez  neorazorx@gmail.com
</span></span><span id="5" class="l"><a class="l" href="#5">  5: </a><span class="php-comment"> *
</span></span><span id="6" class="l"><a class="l" href="#6">  6: </a><span class="php-comment"> * This program is free software: you can redistribute it and/or modify
</span></span><span id="7" class="l"><a class="l" href="#7">  7: </a><span class="php-comment"> * it under the terms of the GNU Affero General Public License as
</span></span><span id="8" class="l"><a class="l" href="#8">  8: </a><span class="php-comment"> * published by the Free Software Foundation, either version 3 of the
</span></span><span id="9" class="l"><a class="l" href="#9">  9: </a><span class="php-comment"> * License, or (at your option) any later version.
</span></span><span id="10" class="l"><a class="l" href="#10"> 10: </a><span class="php-comment"> *
</span></span><span id="11" class="l"><a class="l" href="#11"> 11: </a><span class="php-comment"> * This program is distributed in the hope that it will be useful,
</span></span><span id="12" class="l"><a class="l" href="#12"> 12: </a><span class="php-comment"> * but WITHOUT ANY WARRANTY; without even the implied warranty of
</span></span><span id="13" class="l"><a class="l" href="#13"> 13: </a><span class="php-comment"> * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
</span></span><span id="14" class="l"><a class="l" href="#14"> 14: </a><span class="php-comment"> * GNU Affero General Public License for more details.
</span></span><span id="15" class="l"><a class="l" href="#15"> 15: </a><span class="php-comment"> * 
</span></span><span id="16" class="l"><a class="l" href="#16"> 16: </a><span class="php-comment"> * You should have received a copy of the GNU Affero General Public License
</span></span><span id="17" class="l"><a class="l" href="#17"> 17: </a><span class="php-comment"> * along with this program.  If not, see &lt;http://www.gnu.org/licenses/&gt;.
</span></span><span id="18" class="l"><a class="l" href="#18"> 18: </a><span class="php-comment"> */</span>
</span><span id="19" class="l"><a class="l" href="#19"> 19: </a>
</span><span id="20" class="l"><a class="l" href="#20"> 20: </a><span class="php-keyword1">require_once</span> <span class="php-quote">'base/fs_model.php'</span>;
</span><span id="21" class="l"><a class="l" href="#21"> 21: </a>require_model(<span class="php-quote">'articulo.php'</span>);
</span><span id="22" class="l"><a class="l" href="#22"> 22: </a>require_model(<span class="php-quote">'proveedor.php'</span>);
</span><span id="23" class="l"><a class="l" href="#23"> 23: </a>
</span><span id="24" class="l"><a class="l" href="#24"> 24: </a><span class="php-comment">/**
</span></span><span id="25" class="l"><a class="l" href="#25"> 25: </a><span class="php-comment"> * Una familia de artículos (el equivalente a la marca del artículo).
</span></span><span id="26" class="l"><a class="l" href="#26"> 26: </a><span class="php-comment"> */</span>
</span><span id="27" class="l"><a class="l" href="#27"> 27: </a><span class="php-keyword1">class</span> <a id="familia" href="#familia">familia</a> <span class="php-keyword1">extends</span> fs_model
</span><span id="28" class="l"><a class="l" href="#28"> 28: </a>{
</span><span id="29" class="l"><a class="l" href="#29"> 29: </a>   <span class="php-keyword1">public</span> <span class="php-var"><a id="$codfamilia" href="#$codfamilia">$codfamilia</a></span>;
</span><span id="30" class="l"><a class="l" href="#30"> 30: </a>   <span class="php-keyword1">public</span> <span class="php-var"><a id="$descripcion" href="#$descripcion">$descripcion</a></span>;
</span><span id="31" class="l"><a class="l" href="#31"> 31: </a>   
</span><span id="32" class="l"><a class="l" href="#32"> 32: </a>   <span class="php-keyword1">public</span> <span class="php-var"><a id="$stats" href="#$stats">$stats</a></span>;
</span><span id="33" class="l"><a class="l" href="#33"> 33: </a>   
</span><span id="34" class="l"><a class="l" href="#34"> 34: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___construct" href="#___construct">__construct</a>(<span class="php-var">$f</span>=<span class="php-keyword1">FALSE</span>)
</span><span id="35" class="l"><a class="l" href="#35"> 35: </a>   {
</span><span id="36" class="l"><a class="l" href="#36"> 36: </a>      parent::__construct(<span class="php-quote">'familias'</span>);
</span><span id="37" class="l"><a class="l" href="#37"> 37: </a>      <span class="php-keyword1">if</span>(<span class="php-var">$f</span>)
</span><span id="38" class="l"><a class="l" href="#38"> 38: </a>      {
</span><span id="39" class="l"><a class="l" href="#39"> 39: </a>         <span class="php-var">$this</span>-&gt;codfamilia = <span class="php-var">$f</span>[<span class="php-quote">'codfamilia'</span>];
</span><span id="40" class="l"><a class="l" href="#40"> 40: </a>         <span class="php-var">$this</span>-&gt;descripcion = <span class="php-var">$f</span>[<span class="php-quote">'descripcion'</span>];
</span><span id="41" class="l"><a class="l" href="#41"> 41: </a>      }
</span><span id="42" class="l"><a class="l" href="#42"> 42: </a>      <span class="php-keyword1">else</span>
</span><span id="43" class="l"><a class="l" href="#43"> 43: </a>      {
</span><span id="44" class="l"><a class="l" href="#44"> 44: </a>         <span class="php-var">$this</span>-&gt;codfamilia = <span class="php-keyword1">NULL</span>;
</span><span id="45" class="l"><a class="l" href="#45"> 45: </a>         <span class="php-var">$this</span>-&gt;descripcion = <span class="php-quote">''</span>;
</span><span id="46" class="l"><a class="l" href="#46"> 46: </a>      }
</span><span id="47" class="l"><a class="l" href="#47"> 47: </a>      
</span><span id="48" class="l"><a class="l" href="#48"> 48: </a>      <span class="php-var">$this</span>-&gt;stats = <span class="php-keyword1">array</span>(
</span><span id="49" class="l"><a class="l" href="#49"> 49: </a>          <span class="php-quote">'articulos'</span> =&gt; <span class="php-num">0</span>,
</span><span id="50" class="l"><a class="l" href="#50"> 50: </a>          <span class="php-quote">'con_stock'</span> =&gt; <span class="php-num">0</span>,
</span><span id="51" class="l"><a class="l" href="#51"> 51: </a>          <span class="php-quote">'bloqueados'</span> =&gt; <span class="php-num">0</span>,
</span><span id="52" class="l"><a class="l" href="#52"> 52: </a>          <span class="php-quote">'publicos'</span> =&gt; <span class="php-num">0</span>,
</span><span id="53" class="l"><a class="l" href="#53"> 53: </a>          <span class="php-quote">'factualizado'</span> =&gt; <span class="php-keyword2">Date</span>(<span class="php-quote">'d-m-Y'</span>, <span class="php-keyword2">strtotime</span>(<span class="php-num">0</span>) )
</span><span id="54" class="l"><a class="l" href="#54"> 54: </a>      );
</span><span id="55" class="l"><a class="l" href="#55"> 55: </a>   }
</span><span id="56" class="l"><a class="l" href="#56"> 56: </a>   
</span><span id="57" class="l"><a class="l" href="#57"> 57: </a>   <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_install" href="#_install">install</a>()
</span><span id="58" class="l"><a class="l" href="#58"> 58: </a>   {
</span><span id="59" class="l"><a class="l" href="#59"> 59: </a>      <span class="php-var">$this</span>-&gt;clean_cache();
</span><span id="60" class="l"><a class="l" href="#60"> 60: </a>      <span class="php-keyword1">return</span> <span class="php-quote">&quot;INSERT INTO &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.<span class="php-quote">&quot; (codfamilia,descripcion) VALUES ('VARI','VARIOS');&quot;</span>;
</span><span id="61" class="l"><a class="l" href="#61"> 61: </a>   }
</span><span id="62" class="l"><a class="l" href="#62"> 62: </a>   
</span><span id="63" class="l"><a class="l" href="#63"> 63: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_url" href="#_url">url</a>()
</span><span id="64" class="l"><a class="l" href="#64"> 64: </a>   {
</span><span id="65" class="l"><a class="l" href="#65"> 65: </a>      <span class="php-keyword1">if</span>( <span class="php-keyword2">is_null</span>(<span class="php-var">$this</span>-&gt;codfamilia) )
</span><span id="66" class="l"><a class="l" href="#66"> 66: </a>         <span class="php-keyword1">return</span> <span class="php-quote">&quot;index.php?page=ventas_familias&quot;</span>;
</span><span id="67" class="l"><a class="l" href="#67"> 67: </a>      <span class="php-keyword1">else</span>
</span><span id="68" class="l"><a class="l" href="#68"> 68: </a>         <span class="php-keyword1">return</span> <span class="php-quote">&quot;index.php?page=ventas_familia&amp;cod=&quot;</span>.<span class="php-var">$this</span>-&gt;codfamilia;
</span><span id="69" class="l"><a class="l" href="#69"> 69: </a>   }
</span><span id="70" class="l"><a class="l" href="#70"> 70: </a>   
</span><span id="71" class="l"><a class="l" href="#71"> 71: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_is_default" href="#_is_default">is_default</a>()
</span><span id="72" class="l"><a class="l" href="#72"> 72: </a>   {
</span><span id="73" class="l"><a class="l" href="#73"> 73: </a>      <span class="php-keyword1">return</span> ( <span class="php-var">$this</span>-&gt;codfamilia == <span class="php-var">$this</span>-&gt;default_items-&gt;codfamilia() );
</span><span id="74" class="l"><a class="l" href="#74"> 74: </a>   }
</span><span id="75" class="l"><a class="l" href="#75"> 75: </a>   
</span><span id="76" class="l"><a class="l" href="#76"> 76: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_get" href="#_get">get</a>(<span class="php-var">$cod</span>)
</span><span id="77" class="l"><a class="l" href="#77"> 77: </a>   {
</span><span id="78" class="l"><a class="l" href="#78"> 78: </a>      <span class="php-var">$f</span> = <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">&quot;SELECT * FROM &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.<span class="php-quote">&quot; WHERE codfamilia = &quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$cod</span>).<span class="php-quote">&quot;;&quot;</span>);
</span><span id="79" class="l"><a class="l" href="#79"> 79: </a>      <span class="php-keyword1">if</span>(<span class="php-var">$f</span>)
</span><span id="80" class="l"><a class="l" href="#80"> 80: </a>         <span class="php-keyword1">return</span> <span class="php-keyword1">new</span> familia(<span class="php-var">$f</span>[<span class="php-num">0</span>]);
</span><span id="81" class="l"><a class="l" href="#81"> 81: </a>      <span class="php-keyword1">else</span>
</span><span id="82" class="l"><a class="l" href="#82"> 82: </a>         <span class="php-keyword1">return</span> <span class="php-keyword1">FALSE</span>;
</span><span id="83" class="l"><a class="l" href="#83"> 83: </a>   }
</span><span id="84" class="l"><a class="l" href="#84"> 84: </a>
</span><span id="85" class="l"><a class="l" href="#85"> 85: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_get_articulos" href="#_get_articulos">get_articulos</a>(<span class="php-var">$offset</span>=<span class="php-num">0</span>, <span class="php-var">$limit</span>=FS_ITEM_LIMIT)
</span><span id="86" class="l"><a class="l" href="#86"> 86: </a>   {
</span><span id="87" class="l"><a class="l" href="#87"> 87: </a>      <span class="php-var">$articulo</span> = <span class="php-keyword1">new</span> articulo();
</span><span id="88" class="l"><a class="l" href="#88"> 88: </a>      <span class="php-keyword1">return</span> <span class="php-var">$articulo</span>-&gt;all_from_familia(<span class="php-var">$this</span>-&gt;codfamilia, <span class="php-var">$offset</span>, <span class="php-var">$limit</span>);
</span><span id="89" class="l"><a class="l" href="#89"> 89: </a>   }
</span><span id="90" class="l"><a class="l" href="#90"> 90: </a>   
</span><span id="91" class="l"><a class="l" href="#91"> 91: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_exists" href="#_exists">exists</a>()
</span><span id="92" class="l"><a class="l" href="#92"> 92: </a>   {
</span><span id="93" class="l"><a class="l" href="#93"> 93: </a>      <span class="php-keyword1">if</span>( <span class="php-keyword2">is_null</span>(<span class="php-var">$this</span>-&gt;codfamilia) )
</span><span id="94" class="l"><a class="l" href="#94"> 94: </a>         <span class="php-keyword1">return</span> <span class="php-keyword1">FALSE</span>;
</span><span id="95" class="l"><a class="l" href="#95"> 95: </a>      <span class="php-keyword1">else</span>
</span><span id="96" class="l"><a class="l" href="#96"> 96: </a>         <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">&quot;SELECT * FROM &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.<span class="php-quote">&quot;
</span></span><span id="97" class="l"><a class="l" href="#97"> 97: </a><span class="php-quote">            WHERE codfamilia = &quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;codfamilia).<span class="php-quote">&quot;;&quot;</span>);
</span><span id="98" class="l"><a class="l" href="#98"> 98: </a>   }
</span><span id="99" class="l"><a class="l" href="#99"> 99: </a>   
</span><span id="100" class="l"><a class="l" href="#100">100: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_test" href="#_test">test</a>()
</span><span id="101" class="l"><a class="l" href="#101">101: </a>   {
</span><span id="102" class="l"><a class="l" href="#102">102: </a>      <span class="php-var">$status</span> = <span class="php-keyword1">FALSE</span>;
</span><span id="103" class="l"><a class="l" href="#103">103: </a>      
</span><span id="104" class="l"><a class="l" href="#104">104: </a>      <span class="php-var">$this</span>-&gt;codfamilia = <span class="php-keyword2">trim</span>(<span class="php-var">$this</span>-&gt;codfamilia);
</span><span id="105" class="l"><a class="l" href="#105">105: </a>      <span class="php-var">$this</span>-&gt;descripcion = <span class="php-var">$this</span>-&gt;no_html(<span class="php-var">$this</span>-&gt;descripcion);
</span><span id="106" class="l"><a class="l" href="#106">106: </a>      
</span><span id="107" class="l"><a class="l" href="#107">107: </a>      <span class="php-keyword1">if</span>( !<span class="php-keyword2">preg_match</span>(<span class="php-quote">&quot;/^[A-Z0-9_]{1,4}</span><span class="php-var">$</span><span class="php-quote">/i&quot;</span>, <span class="php-var">$this</span>-&gt;codfamilia) )
</span><span id="108" class="l"><a class="l" href="#108">108: </a>         <span class="php-var">$this</span>-&gt;new_error_msg(<span class="php-quote">&quot;Código de familia no válido. Deben ser entre 1 y 4 caracteres alfanuméricos.&quot;</span>);
</span><span id="109" class="l"><a class="l" href="#109">109: </a>      <span class="php-keyword1">else</span> <span class="php-keyword1">if</span>( <span class="php-keyword2">strlen</span>(<span class="php-var">$this</span>-&gt;descripcion) &lt; <span class="php-num">1</span> <span class="php-keyword1">OR</span> <span class="php-keyword2">strlen</span>(<span class="php-var">$this</span>-&gt;descripcion) &gt; <span class="php-num">100</span> )
</span><span id="110" class="l"><a class="l" href="#110">110: </a>         <span class="php-var">$this</span>-&gt;new_error_msg(<span class="php-quote">&quot;Descripción de familia no válida.&quot;</span>);
</span><span id="111" class="l"><a class="l" href="#111">111: </a>      <span class="php-keyword1">else</span>
</span><span id="112" class="l"><a class="l" href="#112">112: </a>         <span class="php-var">$status</span> = <span class="php-keyword1">TRUE</span>;
</span><span id="113" class="l"><a class="l" href="#113">113: </a>      
</span><span id="114" class="l"><a class="l" href="#114">114: </a>      <span class="php-keyword1">return</span> <span class="php-var">$status</span>;
</span><span id="115" class="l"><a class="l" href="#115">115: </a>   }
</span><span id="116" class="l"><a class="l" href="#116">116: </a>   
</span><span id="117" class="l"><a class="l" href="#117">117: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_save" href="#_save">save</a>()
</span><span id="118" class="l"><a class="l" href="#118">118: </a>   {
</span><span id="119" class="l"><a class="l" href="#119">119: </a>      <span class="php-keyword1">if</span>( <span class="php-var">$this</span>-&gt;test() )
</span><span id="120" class="l"><a class="l" href="#120">120: </a>      {
</span><span id="121" class="l"><a class="l" href="#121">121: </a>         <span class="php-var">$this</span>-&gt;clean_cache();
</span><span id="122" class="l"><a class="l" href="#122">122: </a>         <span class="php-keyword1">if</span>( <span class="php-var">$this</span>-&gt;exists() )
</span><span id="123" class="l"><a class="l" href="#123">123: </a>            <span class="php-var">$sql</span> = <span class="php-quote">&quot;UPDATE &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.<span class="php-quote">&quot; SET descripcion = &quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;descripcion).<span class="php-quote">&quot;
</span></span><span id="124" class="l"><a class="l" href="#124">124: </a><span class="php-quote">               WHERE codfamilia = &quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;codfamilia).<span class="php-quote">&quot;;&quot;</span>;
</span><span id="125" class="l"><a class="l" href="#125">125: </a>         <span class="php-keyword1">else</span>
</span><span id="126" class="l"><a class="l" href="#126">126: </a>            <span class="php-var">$sql</span> = <span class="php-quote">&quot;INSERT INTO &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.<span class="php-quote">&quot; (codfamilia,descripcion) VALUES
</span></span><span id="127" class="l"><a class="l" href="#127">127: </a><span class="php-quote">               (&quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;codfamilia).<span class="php-quote">&quot;,&quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;descripcion).<span class="php-quote">&quot;);&quot;</span>;
</span><span id="128" class="l"><a class="l" href="#128">128: </a>         <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;db-&gt;<span class="php-keyword2">exec</span>(<span class="php-var">$sql</span>);
</span><span id="129" class="l"><a class="l" href="#129">129: </a>      }
</span><span id="130" class="l"><a class="l" href="#130">130: </a>      <span class="php-keyword1">else</span>
</span><span id="131" class="l"><a class="l" href="#131">131: </a>         <span class="php-keyword1">return</span> <span class="php-keyword1">FALSE</span>;
</span><span id="132" class="l"><a class="l" href="#132">132: </a>   }
</span><span id="133" class="l"><a class="l" href="#133">133: </a>   
</span><span id="134" class="l"><a class="l" href="#134">134: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <span class="php-keyword2">delete</span>()
</span><span id="135" class="l"><a class="l" href="#135">135: </a>   {
</span><span id="136" class="l"><a class="l" href="#136">136: </a>      <span class="php-var">$this</span>-&gt;clean_cache();
</span><span id="137" class="l"><a class="l" href="#137">137: </a>      <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;db-&gt;<span class="php-keyword2">exec</span>(<span class="php-quote">&quot;DELETE FROM &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.<span class="php-quote">&quot; WHERE codfamilia = &quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;codfamilia).<span class="php-quote">&quot;;&quot;</span>);
</span><span id="138" class="l"><a class="l" href="#138">138: </a>   }
</span><span id="139" class="l"><a class="l" href="#139">139: </a>   
</span><span id="140" class="l"><a class="l" href="#140">140: </a>   <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_clean_cache" href="#_clean_cache">clean_cache</a>()
</span><span id="141" class="l"><a class="l" href="#141">141: </a>   {
</span><span id="142" class="l"><a class="l" href="#142">142: </a>      <span class="php-var">$this</span>-&gt;cache-&gt;<span class="php-keyword2">delete</span>(<span class="php-quote">'m_familia_all'</span>);
</span><span id="143" class="l"><a class="l" href="#143">143: </a>   }
</span><span id="144" class="l"><a class="l" href="#144">144: </a>   
</span><span id="145" class="l"><a class="l" href="#145">145: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_all" href="#_all">all</a>()
</span><span id="146" class="l"><a class="l" href="#146">146: </a>   {
</span><span id="147" class="l"><a class="l" href="#147">147: </a>      <span class="php-var">$famlist</span> = <span class="php-var">$this</span>-&gt;cache-&gt;get_array(<span class="php-quote">'m_familia_all'</span>);
</span><span id="148" class="l"><a class="l" href="#148">148: </a>      <span class="php-keyword1">if</span>( !<span class="php-var">$famlist</span> )
</span><span id="149" class="l"><a class="l" href="#149">149: </a>      {
</span><span id="150" class="l"><a class="l" href="#150">150: </a>         <span class="php-var">$familias</span> = <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">&quot;SELECT * FROM &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.<span class="php-quote">&quot; ORDER BY descripcion ASC;&quot;</span>);
</span><span id="151" class="l"><a class="l" href="#151">151: </a>         <span class="php-keyword1">if</span>(<span class="php-var">$familias</span>)
</span><span id="152" class="l"><a class="l" href="#152">152: </a>         {
</span><span id="153" class="l"><a class="l" href="#153">153: </a>            <span class="php-keyword1">foreach</span>(<span class="php-var">$familias</span> <span class="php-keyword1">as</span> <span class="php-var">$f</span>)
</span><span id="154" class="l"><a class="l" href="#154">154: </a>               <span class="php-var">$famlist</span>[] = <span class="php-keyword1">new</span> familia(<span class="php-var">$f</span>);
</span><span id="155" class="l"><a class="l" href="#155">155: </a>         }
</span><span id="156" class="l"><a class="l" href="#156">156: </a>         <span class="php-var">$this</span>-&gt;cache-&gt;set(<span class="php-quote">'m_familia_all'</span>, <span class="php-var">$famlist</span>);
</span><span id="157" class="l"><a class="l" href="#157">157: </a>      }
</span><span id="158" class="l"><a class="l" href="#158">158: </a>      <span class="php-keyword1">return</span> <span class="php-var">$famlist</span>;
</span><span id="159" class="l"><a class="l" href="#159">159: </a>   }
</span><span id="160" class="l"><a class="l" href="#160">160: </a>   
</span><span id="161" class="l"><a class="l" href="#161">161: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_search" href="#_search">search</a>(<span class="php-var">$query</span>)
</span><span id="162" class="l"><a class="l" href="#162">162: </a>   {
</span><span id="163" class="l"><a class="l" href="#163">163: </a>      <span class="php-var">$famlist</span> = <span class="php-keyword1">array</span>();
</span><span id="164" class="l"><a class="l" href="#164">164: </a>      <span class="php-var">$query</span> = <span class="php-var">$this</span>-&gt;no_html( <span class="php-keyword2">strtolower</span>(<span class="php-var">$query</span>) );
</span><span id="165" class="l"><a class="l" href="#165">165: </a>      
</span><span id="166" class="l"><a class="l" href="#166">166: </a>      <span class="php-var">$familias</span> = <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">&quot;SELECT * FROM &quot;</span>.<span class="php-var">$this</span>-&gt;table_name.
</span><span id="167" class="l"><a class="l" href="#167">167: </a>              <span class="php-quote">&quot; WHERE lower(descripcion) LIKE '%&quot;</span>.<span class="php-var">$query</span>.<span class="php-quote">&quot;%' ORDER BY descripcion ASC;&quot;</span>);
</span><span id="168" class="l"><a class="l" href="#168">168: </a>      <span class="php-keyword1">if</span>(<span class="php-var">$familias</span>)
</span><span id="169" class="l"><a class="l" href="#169">169: </a>      {
</span><span id="170" class="l"><a class="l" href="#170">170: </a>         <span class="php-keyword1">foreach</span>(<span class="php-var">$familias</span> <span class="php-keyword1">as</span> <span class="php-var">$f</span>)
</span><span id="171" class="l"><a class="l" href="#171">171: </a>            <span class="php-var">$famlist</span>[] = <span class="php-keyword1">new</span> familia(<span class="php-var">$f</span>);
</span><span id="172" class="l"><a class="l" href="#172">172: </a>      }
</span><span id="173" class="l"><a class="l" href="#173">173: </a>      
</span><span id="174" class="l"><a class="l" href="#174">174: </a>      <span class="php-keyword1">return</span> <span class="php-var">$famlist</span>;
</span><span id="175" class="l"><a class="l" href="#175">175: </a>   }
</span><span id="176" class="l"><a class="l" href="#176">176: </a>   
</span><span id="177" class="l"><a class="l" href="#177">177: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_stats" href="#_stats">stats</a>()
</span><span id="178" class="l"><a class="l" href="#178">178: </a>   {
</span><span id="179" class="l"><a class="l" href="#179">179: </a>      <span class="php-var">$aux</span> = <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">&quot;SELECT GREATEST( COUNT(referencia), 0) as art,
</span></span><span id="180" class="l"><a class="l" href="#180">180: </a><span class="php-quote">         GREATEST( SUM(case when stockfis &gt; 0 then 1 else 0 end), 0) as stock,
</span></span><span id="181" class="l"><a class="l" href="#181">181: </a><span class="php-quote">         GREATEST( SUM(&quot;</span>.<span class="php-var">$this</span>-&gt;db-&gt;sql_to_int(<span class="php-quote">'bloqueado'</span>).<span class="php-quote">&quot;), 0) as bloq,
</span></span><span id="182" class="l"><a class="l" href="#182">182: </a><span class="php-quote">         GREATEST( SUM(&quot;</span>.<span class="php-var">$this</span>-&gt;db-&gt;sql_to_int(<span class="php-quote">'publico'</span>).<span class="php-quote">&quot;), 0) as publi,
</span></span><span id="183" class="l"><a class="l" href="#183">183: </a><span class="php-quote">         MAX(factualizado) as factualizado
</span></span><span id="184" class="l"><a class="l" href="#184">184: </a><span class="php-quote">         FROM articulos WHERE codfamilia = &quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;codfamilia).<span class="php-quote">&quot;;&quot;</span>);
</span><span id="185" class="l"><a class="l" href="#185">185: </a>      <span class="php-keyword1">if</span>(<span class="php-var">$aux</span>)
</span><span id="186" class="l"><a class="l" href="#186">186: </a>      {
</span><span id="187" class="l"><a class="l" href="#187">187: </a>         <span class="php-var">$this</span>-&gt;stats[<span class="php-quote">'articulos'</span>] = <span class="php-keyword2">intval</span>(<span class="php-var">$aux</span>[<span class="php-num">0</span>][<span class="php-quote">'art'</span>]);
</span><span id="188" class="l"><a class="l" href="#188">188: </a>         <span class="php-var">$this</span>-&gt;stats[<span class="php-quote">'con_stock'</span>] = <span class="php-keyword2">intval</span>(<span class="php-var">$aux</span>[<span class="php-num">0</span>][<span class="php-quote">'stock'</span>]);
</span><span id="189" class="l"><a class="l" href="#189">189: </a>         <span class="php-var">$this</span>-&gt;stats[<span class="php-quote">'bloqueados'</span>] = <span class="php-keyword2">intval</span>(<span class="php-var">$aux</span>[<span class="php-num">0</span>][<span class="php-quote">'bloq'</span>]);
</span><span id="190" class="l"><a class="l" href="#190">190: </a>         <span class="php-var">$this</span>-&gt;stats[<span class="php-quote">'publicos'</span>] = <span class="php-keyword2">intval</span>(<span class="php-var">$aux</span>[<span class="php-num">0</span>][<span class="php-quote">'publi'</span>]);
</span><span id="191" class="l"><a class="l" href="#191">191: </a>         <span class="php-var">$this</span>-&gt;stats[<span class="php-quote">'factualizado'</span>] = <span class="php-keyword2">Date</span>(<span class="php-quote">'d-m-Y'</span>, <span class="php-keyword2">strtotime</span>(<span class="php-var">$aux</span>[<span class="php-num">0</span>][<span class="php-quote">'factualizado'</span>]) );
</span><span id="192" class="l"><a class="l" href="#192">192: </a>      }
</span><span id="193" class="l"><a class="l" href="#193">193: </a>   }
</span><span id="194" class="l"><a class="l" href="#194">194: </a>   
</span><span id="195" class="l"><a class="l" href="#195">195: </a>   <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_proveedores" href="#_proveedores">proveedores</a>()
</span><span id="196" class="l"><a class="l" href="#196">196: </a>   {
</span><span id="197" class="l"><a class="l" href="#197">197: </a>      <span class="php-var">$provelist</span> = <span class="php-keyword1">array</span>();
</span><span id="198" class="l"><a class="l" href="#198">198: </a>      
</span><span id="199" class="l"><a class="l" href="#199">199: </a>      <span class="php-var">$data</span> = <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">&quot;SELECT DISTINCT codproveedor FROM albaranesprov
</span></span><span id="200" class="l"><a class="l" href="#200">200: </a><span class="php-quote">         WHERE idalbaran IN (SELECT DISTINCT idalbaran FROM lineasalbaranesprov WHERE referencia IN
</span></span><span id="201" class="l"><a class="l" href="#201">201: </a><span class="php-quote">         (SELECT referencia FROM articulos WHERE codfamilia = &quot;</span>.<span class="php-var">$this</span>-&gt;var2str(<span class="php-var">$this</span>-&gt;codfamilia).<span class="php-quote">&quot;));&quot;</span>);
</span><span id="202" class="l"><a class="l" href="#202">202: </a>      <span class="php-keyword1">if</span>(<span class="php-var">$data</span>)
</span><span id="203" class="l"><a class="l" href="#203">203: </a>      {
</span><span id="204" class="l"><a class="l" href="#204">204: </a>         <span class="php-var">$pro0</span> = <span class="php-keyword1">new</span> proveedor();
</span><span id="205" class="l"><a class="l" href="#205">205: </a>         <span class="php-keyword1">foreach</span>(<span class="php-var">$data</span> <span class="php-keyword1">as</span> <span class="php-var">$d</span>)
</span><span id="206" class="l"><a class="l" href="#206">206: </a>            <span class="php-var">$provelist</span>[] = <span class="php-var">$pro0</span>-&gt;get(<span class="php-var">$d</span>[<span class="php-quote">'codproveedor'</span>]);
</span><span id="207" class="l"><a class="l" href="#207">207: </a>      }
</span><span id="208" class="l"><a class="l" href="#208">208: </a>      
</span><span id="209" class="l"><a class="l" href="#209">209: </a>      <span class="php-keyword1">return</span> <span class="php-var">$provelist</span>;
</span><span id="210" class="l"><a class="l" href="#210">210: </a>   }
</span><span id="211" class="l"><a class="l" href="#211">211: </a>}
</span><span id="212" class="l"><a class="l" href="#212">212: </a></span></code></pre>

	<div id="footer">
		 API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
	</div>
</div>
</div>
</body>
</html>
